looking for someone to do this   Review Be able to explain, define or identify the following terms: Entity                                       Table                                       RDBMSAttribute                                   Relat

looking for someone to do this 

 Review 

Be able to explain, define or identify the following terms:

Entity                                       Table                                       RDBMS

Attribute                                   Relationship                             Constraint

DDL                                        Tuple                                       Row    

Chen Notation                         Crow’s Foot Notation               N:M Relationship

Cursor                                      Derived Attributes                    Cardinality                  
NULL                                      Mandatory Participation           Data redundancy
Data                                         Field                                        ER Model

File                                          Data Model                              SQL

DML                                        Candidate Key                         Normalization

Primary Key                             Foreign Key                             Composite Key

1:1 Relationships                     1:M Relationships                    Recursive Relationship

aggregate functions                  Group by                                 Identifier

Join                                          Trigger                                     Relation

Surrogate Key                          Super Key                                Index

View                                        Referential Integrity     

1^st Normal Form                        2^nd Normal Form                       3^rd Normal Form

Partial Dependency     

Components of a database system

Codd’s 8 rules to be a relation

Recognize code for Stored Proc, Function, and Trigger

Modification Anomaly (Three kinds)

Data vs. Information

Unstructured Data vs. Structured Data

Be prepared to write SQL to create a table including an Identity.

Be prepared to write SQL to create a foreign key constraint.

Be prepared to write SQL to solve a problem.

Be prepared to draw a ERD using crowfoot notation.